Financial postings of Invoice Accrual

This functionality is specific for India.

In Order Management, the tax related amounts and landed cost amounts incurred on a purchase order are not included at the time of purchase order receipt in standard Infor LN. These amounts are added to invoice accrual in Financials for India Localization.

Note

The additional costs charged by the main business partner are only added to the invoice accrual. The taxes that are payable to supplier are also added to invoice accrual. Import taxes are not added to invoice accrual.

The expensed taxes are added to invoice accrual through integration transaction when you confirm the warehouse receipt.

The claimable taxes are added to the invoice accrual after you process the order tax details in the Process Order Tax Details (tfacp9235m00l) session.

In the below example, the postings are explained with an example. The tax related ledger accounts are defined the Posting Data for Tax Codes (tfgld0171s000) session. The Accounts payable control account is defined in the Accounts by Financial BP Group (tfacp0110m100) session, and Invoice accrual is defined for integration transactions, in the Mapping Scheme (tfgld4573m000) session.

DetailsReceiptInvoiced
Order10001000
ACR (actual claimable tax at receipt) for example, BED100100
AER (actual expensed tax at receipt) for example, CST200200
ECR (Estimated claimable tax at receipt) for example, VAT300310
EER (Estimated expensed tax at receipt) for example, BED400405

 

GRNI (Invoice accrual) = Base amount + other charges of main business partner + expensed tax amount + claimable taxes (processed through order tax details)

The following are the tax postings of invoice accrual:
Step 1. Purchase order approval.

When purchase order is approved in Order Management.

IDT 10001060 Purchase order
Debit / CreditLedger accountAmountReconciliation Group
DebitGoods to be receivedINR 1000End Account 104
CreditPurchase commitmentsINR 1000End Account 113

 

Step 2. Confirm Purchase Receipt

LN creates the integration transaction when you confirm the purchase receipt

IDT 10001074 purchase order receipt
Debit / CreditLedger accountAmountReconciliation Group
DebitInterim Transit -GeneralINR 1600interim transit 1
CreditInvoice Accrual -purchase order receiptINR 1600Invoice accrual 3

 

Step 3. Confirm Warehouse receipt

LN creates the integration transaction when you confirm the receipt in Warehousing.

IDT 10061086 Warehouse receipt
Debit / CreditLedger accountAmountReconciliation Group
DebitInventoryINR 1600inventory 1
CreditInvoice accrual -receipts invoicedINR 1600invoice accrual 12

 

Step 4. Process order tax details

After tax order details are processed in the Process Order Tax Details (tfacp9235m00l) session, following postings are generated.

For actual claimable at receipt amounts
Debit / CreditLedger accountAmountReconciliation Group
DebitTax Account(Actual claimabe at receipt)INR 100not applicable
CreditInvoice AccrualINR 100invoice accrual 12

 

For estimated claimable at receipt amounts
Debit / CreditLedger accountAmountReconciliation Group
DebitTax clearing account(Estimated claimable at receipt)INR 300not applicable
CreditInvoice accrualINR 300invoice accrual 12

 

Step 5. Register purchase invoice

At invoice registration or matching

Debit / CreditLedger accountAmountReconciliation Group
DebitRegistered purchase invoicesINR 1000not applicable
DebitInvoice accrual (Claimable amounts 300 + 100)INR 400Invoice accrual 3
DebitTax clearing account (Tax expensed at receipt)INR 200not applicable
DebitPurchase tax account (tax claimable at invoice)INR 310not applicable
DebitTax clearing account (tax expensed at receipt)INR 405not applicable
CreditTax clearing account (Actual claimable at invoice)INR 300not applicable
CreditAccounts Payable control accountINR 2015not applicable

 

Step 6. Invoice Approval

At invoice approval:

invoice approval
Debit / CreditLedger accountAmountReconciliation Group
DebitInvoice accrualINR 1000invoice accrual 12
CreditRegistered purchase invoicesINR 1000not applicable

 

Step 7. Process inventory variance

Price variance

IDT 10001065 Purchase order/ price variance
Debit / CreditLedger accountAmountReconciliation Group
DebitInterim VarianceINR -5interim variance 1
CreditInvoice Accrual -purchase order receiptINR -5Invoice accrual 3

 

Inventory variance

IDT 100061038 Purchase order/ inventory variance
Debit / CreditLedger accountAmountReconciliation Group
DebitInterim VarianceINR 5interim variance 1
CreditInvoice Accrual -purchase order receiptINR 5Invoice accrual 3