About Updating to AP from a Material Payment Batch

When you post a material payment batch, the system creates AP invoices based on the information provided in MS Material Payment Worksheet.

The information from the material payment worksheet is used to create expense invoice transactions in Accounts Payable and post corresponding GL distributions in General Ledger. Once the batch is posted, any changes to the material payment information (unit cost, tax code, etc.), along with the assigned AP Reference are updated back to the Transaction Detail table (MSTD).

The system creates a single AP invoice for each sequence in the batch. Separate expense lines will be created for each Material Expense GL Account to be debited. Material Expense accounts are based on the 'sell from' location and sale type, with overrides by 'sell to' company, material category, or 'sell to' company and material category. If offering discounts and expensing net amounts (i.e. Post Discounts Offered to GL and Net Amounts to Subledgers option is checked in AP Company Parameters), separate expense lines will also be created for each discount offered.

Updates to GL are controlled by the GL Expense Posting level selected for expense transactions in AP Company Parameters.

  • Summary - If interfaced at this level, entries will be summarized and one entry will be posted to GL per each batch sequence, GL company, and GL account. The Summary GL Description specified for expense transactions will be used as the GL transaction description.

  • Transaction - If interfaced at this level, one entry will be posted to GL for each batch sequence, GL company, GL account, and transaction number. Vendor #, Sort Name, AP Reference, and/or other fields selected for that level of update in AP Company will be used to create the GL transaction description.

  • Line - If interfaced at this level, one entry will be posted to GL for each batch sequence, GL company, GL account, transaction number, and line. Vendor #, Sort Name, AP Reference, and/or other fields selected for that level of update in AP Company will be used to create the GL transaction description.

GL Distributions - AP GL Company

Debit

Credit

Intercompany AR GL Account

(Based on the MS and AP GL Companies. Offsets the haul expense payable. Only used if the MS & AP GL Companies are not equal.)

Accounts Payable GL Account

(Based on the Expense Pay Type assigned in AP Company Parameters. Use total invoice amount.)

GL Distributions - MS/IN GL Company

Debit

Credit

Haul Expense GL Account

(Based on the location and sale type, with overrides by ‘sell to’ company, material category, or both.)

InterCo AP GL Account

(Based on the MS and AP GL Companies.Offsets the haul expense. Only used if the MS & AP GL companies are not equal.