SBX - Search With Button

SBX - Forum Post Title

Purchase Order Product Receipt and Vendor Invoice Posting in Dynamics AX 2012 R3

Microsoft Dynamics AX Forum

Alison Creech asked a question on 11 Oct 2018 10:51 AM

Question Status

Unanswered

Hello, 

We are currently upgrading from MS Dynamics AX 2012 R2 to AX 2012 R3.  We are discovering that the General Ledger posting on Legacy transactions (PO's received in R2 but invoiced in R3) are not reversing correctly.  The Purchase expenditure, un-invoiced and Purchase, accrual accounts are not reversing in the general ledger.  However, the entry does appear in the Subledger as entry type of Liability accrual.   T accounts show our Purchase expenditure, un-invoiced account is holding a DR balance and Purchase, accrual account is holding a CR balance.

Example:

Transactions from product receipt

Ledger posting

Journal number Voucher Date Created date and time Ledger account Currency Posting type Amount in transaction currency Amount Amount in reporting currency Posting layer
GJX008003918 PR100771979 5/31/2018 5/31/2018 12:21 134999-ILFT-ROA-PT USD Purchase expenditure, un-invoiced 165.96 165.96 165.96 Current
GJX008003918 PR100771979 5/31/2018 5/31/2018 12:21 229999-ILFT-ROA-PT USD Purchase, accrual -165.96 -165.96 -165.96 Current
GJX008003919 RCV0754631 5/31/2018 5/31/2018 12:21 134999-ILFT-ROA-PT USD Purchase expenditure, un-invoiced -165.96 -165.96 -165.96 Current
GJX008003919 RCV0754631 5/31/2018 5/31/2018 12:21 134200-ILFT-ROA-PT USD Product receipt 165.96 165.96 165.96 Current

  

Subledger for the product receipt

Document Subledger journal Entry type Posting type Ledger account Currency Debit Credit Reporting currency Debit2 Credit2
PR100771979 SJE1413179 Liability accrual Purchase expenditure, un-invoiced 134999-ILFT-ROA-PT USD 165.96 0.00 USD 165.96 0.00
PR100771979 SJE1413179 Liability accrual Purchase, accrual 229999-ILFT-ROA-PT USD 0.00 165.96 USD 0.00 165.96

 

Transactions from Vendor invoice posting

Ledger posting

Journal number Voucher Date Created date and time Ledger account Currency Posting type Amount in transaction currency Amount Amount in reporting currency Posting layer
GJX008032611 APIV110318251 10/9/2018 10/9/2018 15:47 221400 USD Vendor balance -165.96 -165.96 -165.96 Current
GJX008032611 APIV110318251 10/9/2018 10/9/2018 15:47 134999-ILFT-ROA-PT USD Purchase expenditure, un-invoiced 165.96 165.96 165.96 Current
GJX008032611 APIV110318251 10/9/2018 10/9/2018 15:47 134999-ILFT-ROA-PT USD Purchase expenditure for product 0.00 0.00 0.00 Current
GJX008032611 APIV110318251 10/9/2018 10/9/2018 15:47 134200-ILFT-ROA-PT USD Purchase, inventory receipt 165.96 165.96 165.96 Current
GJX008032611 APIV110318251 10/9/2018 10/9/2018 15:47 134200-ILFT-ROA-PT USD Product receipt -165.96 -165.96 -165.96 Current

Subledger for Vendor invoice

Document Subledger journal Entry type Posting type Ledger account Currency Debit Credit Reporting currency Debit2 Credit2
APIV110318251 SJE1416397 None Vendor balance 221400 USD 0.00 165.96 USD 0.00 165.96
APIV110318251 SJE1416397 None Purchase expenditure for product 134999-ILFT-ROA-PT USD 165.96 0.00 USD 165.96 0.00
APIV110318251 SJE1416397 None Purchase expenditure for product 134999-ILFT-ROA-PT USD 0.00 165.96 USD 0.00 165.96
APIV110318251 SJE1416397 None Product receipt 134200-ILFT-ROA-PT USD 0.00 165.96 USD 0.00 165.96
APIV110318251 SJE1416397 None Purchase expenditure, un-invoiced 134999-ILFT-ROA-PT USD 165.96 0.00 USD 165.96 0.00
APIV110318251 SJE1416397 None Purchase, inventory receipt 134200-ILFT-ROA-PT USD 165.96 0.00 USD 165.96 0.00
APIV110318251 SJE1416398 Liability accrual Purchase expenditure, un-invoiced 134999-ILFT-ROA-PT USD 0.00 165.96 USD 0.00 165.96
APIV110318251 SJE1416398 Liability accrual Purchase, accrual 229999-ILFT-ROA-PT USD 165.96 0.00 USD 165.96 0.00

T Accts

134999 229999
DR CR DR CR
165.96 165.96   165.96
165.96 0.00  
     
   
   
134200 221400
DR CR DR CR
165.96 165.96   165.96
165.96    
   

Are we missing something in our configuration?  Have you come across this issue before?  What do we need to do before we go live with the R3 environment?

Thank you for your help!

Reply

Hi,

Can you share the setups that have been made in the inventory posting matrix for your items/item groups?

Many thanks and best regards

Ludwig

Reply
Alison Creech responded on 11 Oct 2018 2:11 PM

This is under Purchase order

Item group Other Parts

Account type/Main account

Product receipt/134200

Purchase expenditure, un-invoiced /134999

Purchase, inventory receipt/134200

Purchase expenditure for product/134999

Discount/Blank

Fixed receipt price profit/Blank

Fixed receipt price loss Fixed receipt price offset/Blank

Charge/Blank

Stock variation /blank

Purchase, accrual/229999

Accrued sales tax on receipt/blank

Purchase price variance/524400

Fixed asset receipt/blank

Prepayment/blank

Purchase expenditure for expense/blank

In item model groups

the accrue liability on product receipt is checked

Reply

SBX - Two Col Forum

SBX - Migrated JS