Skip to main content
Question

Bill header calculated figures are incorrect

  • May 21, 2026
  • 2 replies
  • 27 views
J
Freshman I

I have created a Bill using PUT /Bill REST API endpoint and it created below data, the process also includes releasing the bill but I am encountering a “The document is out of balance” error. It seems the bill header total figures were not calculated correctly. For this bill, I created its own PO and PO Receipt with vendor’s Allow AP Bill Before Receipt unticked (3way match)

On second screenshot, I checked the PO Receipt linked to the Bill and based on the Billing tab, it shows Billed Amount as 550 which is correct and matched with the Bill line’s Amount. I am not sure what needs to be added on the payload when calling /Bill API endpoint but when I used UI to create Bill from PO receipt, I don’t encounter the “The document is out of balance” error.

Thanks!



 

    2 replies

    RohitRattan88
    Acumatica Moderator
    Forum|alt.badge.img+4
    • RohitRattan88
    • Acumatica Moderator
    • May 21, 2026

    ​@jcoballes 

    Do you have any customizations published? Maybe share postman details(request,response bodies etc) to review issue.

    Behavior is definitely strange. What happens when you create same bill via UI?

      J
      Freshman I
      • jcoballes
      • Author
      • Freshman I
      • May 21, 2026

      ​@jcoballes 

      Do you have any customizations published? Maybe share postman details(request,response bodies etc) to review issue.

      Behavior is definitely strange. What happens when you create same bill via UI?

      Yes, we have customization published. For /Bill API endpoint, we modify it by just adding TaxZoneID on header to be able to set the value for it.

      Using UI, I was able to create and release a bill for both Create AP Bill from Purchase Receipt and Bills & Adjustment (then add PO Receipt Line) and modifying the quantity (to under invoice)

      For the Bill created through API, here are the details:

      PO

      {
          "id": "6d19a17c-a254-f111-bb2d-0680a1edd88b",
          "rowNumber": 1,
          "note": {
              "value": ""
          },
          "BaseCurrencyID": {
              "value": "USD"
          },
          "Branch": {
              "value": "PRODWHOLE"
          },
          "ControlTotal": {
              "value": 600.0000
          },
          "CurrencyEffectiveDate": {
              "value": "2013-01-01T00:00:00+00:00"
          },
          "CurrencyID": {
              "value": "USD"
          },
          "CurrencyRate": {
              "value": 1.00000000
          },
          "CurrencyRateTypeID": {},
          "CurrencyReciprocalRate": {
              "value": 1.00000000
          },
          "Date": {
              "value": "2026-05-20T00:00:00+00:00"
          },
          "Description": {
              "value": "QDAP-248"
          },
          "Details": [
              {
                  "id": "da61bb8d-a254-f111-bb2d-0680a1edd88b",
                  "rowNumber": 1,
                  "note": {
                      "value": ""
                  },
                  "Account": {},
                  "AlternateID": {},
                  "BranchID": {
                      "value": "PRODWHOLE"
                  },
                  "CalculateDiscountsOnImport": {},
                  "Cancelled": {
                      "value": false
                  },
                  "Completed": {
                      "value": true
                  },
                  "CompleteOn": {
                      "value": 100.000000
                  },
                  "Description": {},
                  "ExtendedCost": {
                      "value": 600.0000
                  },
                  "InventoryID": {
                      "value": "AALEGO500"
                  },
                  "LineDescription": {
                      "value": "Lego 500 piece set"
                  },
                  "LineNbr": {
                      "value": 1
                  },
                  "LineType": {
                      "value": "Goods for IN"
                  },
                  "MaxReceiptPercent": {
                      "value": 100.000000
                  },
                  "MinReceiptPercent": {
                      "value": 0.000000
                  },
                  "OrderedQty": {
                      "value": 0.000000
                  },
                  "OrderNbr": {
                      "value": "PO002823"
                  },
                  "OrderQty": {
                      "value": 12.000000
                  },
                  "OrderType": {
                      "value": "RO"
                  },
                  "OrigPONbr": {},
                  "OrigPOType": {},
                  "Project": {
                      "value": "X"
                  },
                  "ProjectTask": {},
                  "Promised": {
                      "value": "2026-05-20T00:00:00+00:00"
                  },
                  "QtyOnReceipts": {
                      "value": 12.000000
                  },
                  "ReceiptAction": {
                      "value": "Accept but Warn"
                  },
                  "ReceivedAmount": {},
                  "Requested": {
                      "value": "2026-05-20T00:00:00+00:00"
                  },
                  "Subaccount": {},
                  "TaxCategory": {
                      "value": "TAXABLE"
                  },
                  "UnitCost": {
                      "value": 50.000000
                  },
                  "UOM": {
                      "value": "EA"
                  },
                  "WarehouseID": {
                      "value": "WHOLESALE"
                  },
                  "custom": {},
                  "_links": {
                      "files:put": "/AcumaticaERP/entity/Quadient/25.200.001/files/PX.Objects.PO.POOrderEntry/Transactions/da61bb8d-a254-f111-bb2d-0680a1edd88b/{filename}"
                  }
              }
          ],
          "Hold": {
              "value": false
          },
          "IsTaxValid": {},
          "LastModifiedDateTime": {
              "value": "2026-05-20T23:21:57.25+00:00"
          },
          "LineTotal": {
              "value": 600.0000
          },
          "Location": {
              "value": "MAIN"
          },
          "OrderNbr": {
              "value": "PO002823"
          },
          "OrderTotal": {
              "value": 600.0000
          },
          "Owner": {
              "value": "3205"
          },
          "Project": {
              "value": "X"
          },
          "PromisedOn": {
              "value": "2026-05-20T00:00:00+00:00"
          },
          "Status": {
              "value": "Completed"
          },
          "TaxTotal": {
              "value": 0.0000
          },
          "Terms": {
              "value": "30D"
          },
          "Type": {
              "value": "Normal"
          },
          "VendorID": {
              "value": "ACITAISYST"
          },
          "VendorRef": {
              "value": "JBC-PO-20260520-4"
          },
          "VendorTaxZone": {},
          "custom": {},
          "_links": {
              "self": "/AcumaticaERP/entity/Quadient/25.200.001/PurchaseOrder/6d19a17c-a254-f111-bb2d-0680a1edd88b",
              "files:put": "/AcumaticaERP/entity/Quadient/25.200.001/files/PX.Objects.PO.POOrderEntry/Document/6d19a17c-a254-f111-bb2d-0680a1edd88b/{filename}"
          }
      }

      Purchase Receipt

      {
          "id": "68a2c89a-a254-f111-bb2d-0680a1edd88b",
          "rowNumber": 1,
          "note": {
              "value": ""
          },
          "BaseCurrencyID": {
              "value": "USD"
          },
          "BillDate": {
              "value": "2026-05-20T00:00:00+00:00"
          },
          "Branch": {
              "value": "PRODWHOLE"
          },
          "ControlQty": {
              "value": 12.000000
          },
          "CreateBill": {
              "value": false
          },
          "CurrencyEffectiveDate": {
              "value": "2013-01-01T00:00:00+00:00"
          },
          "CurrencyID": {
              "value": "USD"
          },
          "CurrencyRate": {
              "value": 1.00000000
          },
          "CurrencyRateTypeID": {},
          "CurrencyReciprocalRate": {
              "value": 1.00000000
          },
          "Date": {
              "value": "2026-05-20T00:00:00+00:00"
          },
          "Details": [
              {
                  "id": "6aa2c89a-a254-f111-bb2d-0680a1edd88b",
                  "rowNumber": 1,
                  "note": {
                      "value": ""
                  },
                  "Account": {},
                  "AccrualAccount": {
                      "value": "20100"
                  },
                  "AccrualSubaccount": {
                      "value": "CON000"
                  },
                  "Branch": {
                      "value": "PRODWHOLE"
                  },
                  "Description": {},
                  "EditableUnitCost": {
                      "value": true
                  },
                  "EstimatedINExtendedCost": {
                      "value": 600.0000
                  },
                  "ExpirationDate": {},
                  "ExtendedCost": {
                      "value": 600.0000
                  },
                  "FinalINExtendedCost": {
                      "value": 600.0000
                  },
                  "InventoryID": {
                      "value": "AALEGO500"
                  },
                  "LineNbr": {
                      "value": 1
                  },
                  "LineType": {
                      "value": "Goods for IN"
                  },
                  "Location": {
                      "value": "R1S1"
                  },
                  "LotSerialNbr": {
                      "value": ""
                  },
                  "OpenQty": {
                      "value": 0.000000
                  },
                  "OrderedQty": {
                      "value": 12.000000
                  },
                  "POLineNbr": {
                      "value": 1
                  },
                  "POOrderNbr": {
                      "value": "PO002823"
                  },
                  "POOrderType": {
                      "value": "Normal"
                  },
                  "POReceiptLineNbr": {},
                  "POReceiptNbr": {},
                  "ReceiptQty": {
                      "value": 12.000000
                  },
                  "Subaccount": {},
                  "TransactionDescription": {
                      "value": "Lego 500 piece set"
                  },
                  "TransferOrderLineNbr": {},
                  "TransferOrderNbr": {},
                  "TransferOrderType": {},
                  "TransferShipmentNbr": {},
                  "UnitCost": {
                      "value": 50.000000
                  },
                  "UOM": {
                      "value": "EA"
                  },
                  "Warehouse": {
                      "value": "WHOLESALE"
                  },
                  "custom": {},
                  "_links": {
                      "files:put": "/AcumaticaERP/entity/Quadient/25.200.001/files/PX.Objects.PO.POReceiptEntry/transactions/6aa2c89a-a254-f111-bb2d-0680a1edd88b/{filename}"
                  }
              }
          ],
          "Hold": {
              "value": false
          },
          "InventoryRefNbr": {
              "value": "002733"
          },
          "LastModifiedDateTime": {
              "value": "2026-05-20T23:21:56.947+00:00"
          },
          "Location": {
              "value": "MAIN"
          },
          "PostPeriod": {
              "value": "052026"
          },
          "ProcessReturnWithOriginalCost": {
              "value": false
          },
          "ReceiptNbr": {
              "value": "PR002745"
          },
          "Status": {
              "value": "Released"
          },
          "TotalCost": {
              "value": 600.0000
          },
          "TotalQty": {
              "value": 12.000000
          },
          "Type": {
              "value": "Receipt"
          },
          "UnbilledQuantity": {
              "value": 12.000000
          },
          "VendorID": {
              "value": "ACITAISYST"
          },
          "VendorRef": {
              "value": "JBC-RCPT-20260520-4"
          },
          "Warehouse": {},
          "custom": {},
          "_links": {
              "self": "/AcumaticaERP/entity/Quadient/25.200.001/PurchaseReceipt/68a2c89a-a254-f111-bb2d-0680a1edd88b",
              "files:put": "/AcumaticaERP/entity/Quadient/25.200.001/files/PX.Objects.PO.POReceiptEntry/Document/68a2c89a-a254-f111-bb2d-0680a1edd88b/{filename}"
          }
      }

      Payload when creating the Bill:

       

      {
          "Type": { "value": "Bill" },
          "Hold": { "value": true },
          "Balance": { "value": 550 },
          "ReferenceNbr": { "value": "006337" },
          "Vendor": { "value": "ACITAISYST" },
          "CurrencyID": { "value": "USD" },
          "Date": { "value": "2026-05-20" },
          "DueDate": { "value": "2026-05-31" },
          "IsTaxValid": { "value": true },
          "VendorRef": { "value": "JBC-INV-20260520-4" },
          "TaxTotal": { "value": 0 },
          "Details": [
            {
              "Branch": { "value": "PRODWHOLE" },
              "InventoryID": { "value": "AALEGO500" },
              "Qty": { "value": 11 },
              "Amount": { "value": 550 },
              "ManualAmount": { "value": true },
              "TransactionDescription": { "value": "Lego 500 piece set" },
              "UnitCost": { "value": 50 },
              "Project": { "value": "X" },
              "TaxCategory": { "value": "EXEMPT" },
              "POReceiptType": { "value": "Receipt" },
              "POReceiptNbr": { "value": "PR002745" },
              "POReceiptLine": { "value": 1 }
            }
          ],
          "TaxDetails": []
        }

      For the payload, I already tried modifying POReceiptType = RT and I also tried with Qty and UnitCost having “commit”: true

      Bill created

      {
          "id": "64357b08-a354-f111-bb2d-0680a1edd88b",
          "rowNumber": 1,
          "note": {
              "value": ""
          },
          "Amount": {
              "value": 250.0000
          },
          "ApprovedForPayment": {
              "value": false
          },
          "Balance": {
              "value": 250.0000
          },
          "BranchID": {
              "value": "PRODWHOLE"
          },
          "CashAccount": {
              "value": "10200"
          },
          "CurrencyID": {
              "value": "USD"
          },
          "Date": {
              "value": "2026-05-20T00:00:00+00:00"
          },
          "Description": {},
          "Details": [
              {
                  "id": "07c601b1-a854-f111-bb2d-0680a1edd88b",
                  "rowNumber": 1,
                  "note": {
                      "value": ""
                  },
                  "Account": {
                      "value": "20100"
                  },
                  "Amount": {
                      "value": 550.0000
                  },
                  "Branch": {
                      "value": "PRODWHOLE"
                  },
                  "CalculateDiscountsOnImport": {},
                  "Description": {
                      "value": "Inventory Purchase Accrual"
                  },
                  "ExtendedCost": {
                      "value": 550.0000
                  },
                  "InventoryID": {
                      "value": "AALEGO500"
                  },
                  "LCLineNbr": {},
                  "LCNbr": {},
                  "LCType": {},
                  "NonBillable": {
                      "value": false
                  },
                  "POLine": {
                      "value": 1
                  },
                  "POOrderNbr": {
                      "value": "PO002823"
                  },
                  "POOrderType": {
                      "value": "Normal"
                  },
                  "POReceiptLine": {
                      "value": 1
                  },
                  "POReceiptNbr": {
                      "value": "PR002745"
                  },
                  "POReceiptType": {
                      "value": "Receipt"
                  },
                  "Project": {
                      "value": "X"
                  },
                  "ProjectTask": {},
                  "Qty": {
                      "value": 11.000000
                  },
                  "Subaccount": {
                      "value": "CON000"
                  },
                  "TaxCategory": {
                      "value": "TAXABLE"
                  },
                  "TransactionDescription": {
                      "value": "Lego 500 piece set"
                  },
                  "UnitCost": {
                      "value": 50.000000
                  },
                  "UOM": {
                      "value": "EA"
                  },
                  "custom": {},
                  "_links": {
                      "files:put": "/AcumaticaERP/entity/Quadient/25.200.001/files/PX.Objects.AP.APInvoiceEntry/Transactions/07c601b1-a854-f111-bb2d-0680a1edd88b/{filename}"
                  }
              }
          ],
          "DueDate": {
              "value": "2026-05-31T00:00:00+00:00"
          },
          "Hold": {
              "value": false
          },
          "IsTaxValid": {},
          "LastModifiedDateTime": {
              "value": "2026-05-21T00:15:40.487+00:00"
          },
          "LocationID": {
              "value": "MAIN"
          },
          "PostPeriod": {
              "value": "052026"
          },
          "Project": {
              "value": "X"
          },
          "ReferenceNbr": {
              "value": "006337"
          },
          "Status": {
              "value": "Balanced"
          },
          "TaxTotal": {
              "value": 0.0000
          },
          "TaxZoneID": {},
          "Terms": {
              "value": "30D"
          },
          "Type": {
              "value": "Bill"
          },
          "Vendor": {
              "value": "ACITAISYST"
          },
          "VendorRef": {
              "value": "JBC-INV-20260520-4"
          },
          "custom": {},
          "_links": {
              "self": "/AcumaticaERP/entity/Quadient/25.200.001/Bill/64357b08-a354-f111-bb2d-0680a1edd88b",
              "files:put": "/AcumaticaERP/entity/Quadient/25.200.001/files/PX.Objects.AP.APInvoiceEntry/Document/64357b08-a354-f111-bb2d-0680a1edd88b/{filename}"
          }
      }

       

      Terms & ConditionsAccessibility statement
      About Acumatica ERP system
      Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
      © 2008 — 2024  Acumatica, Inc. All rights reserved