Skip to main content
Question

Bill header calculated figures are incorrect

  • May 21, 2026
  • 3 replies
  • 35 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!



 

    3 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}"
          }
      }

       

      J
      Freshman I
      • jcoballes
      • Author
      • Freshman I
      • May 22, 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?

      Do you think customization will have an impact on calling /Bill endpoint? But if there’s a possibility of having an impact, why only for kind of scenario (under invoicing) I tried using the Default endpoint and not our customized Web Service endpoint but it’s still the same result

      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