Question

Create Action for adding columns for Bill's Details table

  • 9 February 2023
  • 6 replies
  • 50 views
I
Rank
Userlevel 4
Badge +2

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

6 replies

J
Rank
Userlevel 7
Badge +11

Hi @Ivan 

Answered the same in the below ticket.

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

Jini N
I
Rank
Userlevel 4
Badge +2

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 ? 

I
Rank
Userlevel 4
Badge +2

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

 

I
Rank
Userlevel 4
Badge +2

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"

        }

        

        

      }

Chris Hackett
Rank
Userlevel 7
Badge

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
I
Rank
Userlevel 4
Badge +2

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

No, currently its still now working

Reply


Terms & ConditionsCookie settings
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