Skip to main content

Hi,

Previously, I had experience with default actions for Bill that are depicted at screen

For using them it was enough to send such request 

Our client is using custom entity named Subcontracts

I need to send new fields from this entity to Bill, these fields are SubcontractNbr and SubcontractLine

Client’s Acumatica already contains such actions for this entity

I assume that I need to use addSubContractLines action as I need to add these fields to Bill’s columns in Details

However this action does not contain any parameters

My question is : how to use action for adding these custom fields : SubcontractNbr and SubcontractLine to Bill and how to form such request ?

This is my request for creating Bill

URL : https://mcicj.acumatica.com/entity/ARTSDocAlphaEndpoint/20.200.001/Bill

Body :

{

  "VendorRef": {

    "value": "1ABL-217i941"

  },

  "DueDate": {

    "value": "3/2/2023"

  },

  "Vendor": {

    "value": "V-06702"

  },

  "Date": {

    "value": "1/31/2023"

  },

  "Terms": {

    "value": "PWP"

  },

  "PostPeriod": {

    "value": "01-2023"

  },

  "Details": 

    {

      "Description": {

        "value": "Line 001 - Gypcrete"

      },

      "Qty": {

        "value": 1

      },

      "UnitCost": {

        "value": "34573.2"

      },

      "ExtendedCost": {

        "value": "34573.2"

      },

      "Account": {

        "value": "5430"

      },

      "SubcontractLine": {

        "value": "1"

      },

      "SubcontractNbr": {

        "value": "234567"

      },

      "rowNumber": {

        "value": "1"

      }

    }

  ]

}

Thanks in Advance

Hi @Ivan 

Answered the same in the below ticket.

Two columns are not added to Bill Deatils | Community (acumatica.com)


Hi @Ivan 

Answered the same in the below ticket.

Two columns are not added to Bill Deatils | Community (acumatica.com)

I receive such error 

{

    "message": "An error has occurred.",

    "exceptionMessage": "Bill.CashDiscountDate: 'Cash Discount Date' cannot be empty.\nBill.DueDate: 'Due Date' cannot be empty.\nBill.PostPeriod: Error: The 02-2023 financial period is inactive in the MISTICK company.\nBill.Terms: 'Terms' cannot be empty.\nBill.Vendor: 'Vendor' cannot be empty.\nBill.VendorRef: 'Vendor Ref.' cannot be empty.\n'VendorLocationID' cannot be empty.\nVendorLocationID: 'VendorLocationID' cannot be empty.",

 

Is there any specials requirements to do this ? 


Hi @Ivan 

Answered the same in the below ticket.

Two columns are not added to Bill Deatils | Community (acumatica.com)

 There is also problem with 3 step that you have advised : “Make sure on the bills and adjustment screen, your newly created subcontact showing on the AddSubcontractline popup like below

I tried to create new subcontract + tries to select the existing one but none of them is depicted it this section

 


Hi @Ivan 

Answered the same in the below ticket.

Two columns are not added to Bill Deatils | Community (acumatica.com)

Currently I have 2 problems :

  1. as you suggested

    Make sure on the bills and adjustment screen, your newly created subcontact showing on the AddSubcontractline popup like below

    I tried to create new subcontract + tries to select the existing one but none of them is depicted it this section

    1. I do not know why, but all bills are created with “closed” 

      Here is my request 

      {

        "VendorRef": {

          "value": "12343521"

        },

         "Hold": {

              "value": true

          },

        "DueDate": {

          "value": "3/2/2023"

        },

        "Vendor": {

          "value": "V-02072"

        },

        "Date": {

          "value": "1/31/2023"

        },

        "Terms": {

          "value": "PWP"

        },

        "PostPeriod": {

          "value": "01-2023"

        }

        

        

      }


Hi @Ivan  were you able to find a solution? Thank you!


Hi @Ivan  were you able to find a solution? Thank you!

No, currently its still now working


Reply