Generate Opening Balance Document– A summary of the activity

In this activity, you can generate the opening balance document. The document is generated based on the selected parameters like From/To opening balance number, From/To opening balance date, warehouse number, status, part type, part number and the location.

Report Heading

Opening Balance.

Header Information

Opening Balance #, Warehouse #, Opening Balance Date, Status, User Status and Category.

Columns Printed

Record #, Line #, Part #, Part Description, Part Type, Quantity, Stock UOM, Wh-Zone #, Wh-Bin #, Stock Status, Valuation Method, Part Control Type and Ref Document #  .

Other Details:

User Defined Detail1, User Defined Detail 2 and Remarks.

Serial / Lot Details

Opening Balance #, Warehouse #, Opening Balance Date, Status.

Columns Printed:

Record #, Line #, Part #, Quantity, UOM, Mfr Lot #, Mfr Serial #, Lot #, Serial #, Quantity, Rate, Value, Condition, Certificate Type, Certificate # .

Parameter Information

Columns Printed:

Record #, Line #, Part Serial #, Part #, WL Date, Parameter, UOM, Since New, Since Overhaul, Since Repair, Since Inspection and Since Last Shop Visit, Warranty Y/N, Warranty Value.

Rate and Value Details

Opening Balance #, Warehouse #, Opening Balance Date, Status and Base Currency.

Columns Printed:

Record #, Part #, Part Description, Valuation Method, Lot #, Stock UOM, Total Quantity, Rate, Value, Entry Type, Reference Document # .

Rate Information

Opening Balance #, Warehouse #, Opening Balance Date, Status and Base Currency.

Columns Printed:

Record #, Part #, Valuation Method, Total Quantity, Seq #, Quantity, Stock UOM, Rate, Value and Reference Document #.

Click here to know how to "Generating Opening Balance Document".