Hi Community,
I am working with a customer who uses the D365BC Pre-Payment Functionality on the Purchase Order
- Prepayment Includes tax = yes
- Prepayment % = 50
- Currency Code = ‘’
- Type on Line = Item (Inventory item)
- Tax Liable = yes
- Tax Details work out to calculate 12%
I tested this in their Canadian SaaS environment, as well as a Cronus (no customizations or extensions)
Purchase Order for
- Item (Inventory), 1 EA, $200 + 12% Tax, $224 incl Tax
Post Prepayment Invoice for 50%, including Sales tax
- Debit: Vendor Deposits $113
- Credit: AP -$113
Post Payment for Pre-Payment Invoice
- Debit: AP $113
- Credit: Bank -$113
Post Purchase Receipt
- Debit: Inventory Interim $200
- Credit: Accruals GRNI -$200
Post Purchase Invoice using “Get Receipt Lines”
- Debit: Accruals GRNI $200
- Credit: Inventory Interim -$200
- Debit: Inventory $200
- Credit: Direct Cost Applied -$200
- Debit: Purchase Account $200
- Credit: Vendor Deposits (two entries, -$100 and -$13)
- Debit: Sales Tax $26
- Credit: AP -$126 (should be -$113)
- Debit: Invoice Rounding $13 (should not exist)
It gets even worse when I try to post the Invoice from the Purchase Order
- Debit: Accruals GRNI $200
- Credit: Inventory Interim -$200
- Debit: Inventory $200
- Credit: Direct Cost Applied -$200
- Debit: Purchase Account $200
- Credit: Vendor Deposits -$113 (one entry)
- Debit: Sales Tax $26
- Credit: AP -$98.31 (should be -$113)
- Credit: Invoice Rounding $-14.69 (should not exist)