Skip to main content
Question

Create Action for adding columns for Bill's Details table


Forum|alt.badge.img+2
  • Varsity I
  • 279 replies

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

jinin
Pro I
Forum|alt.badge.img+11
  • Pro I
  • 680 replies
  • February 13, 2023

Forum|alt.badge.img+2
  • Author
  • Varsity I
  • 279 replies
  • February 13, 2023
jinin wrote:

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 ? 


Forum|alt.badge.img+2
  • Author
  • Varsity I
  • 279 replies
  • February 13, 2023
jinin wrote:

 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

 


Forum|alt.badge.img+2
  • Author
  • Varsity I
  • 279 replies
  • February 13, 2023
jinin wrote:

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
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • March 20, 2023

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


Forum|alt.badge.img+2
  • Author
  • Varsity I
  • 279 replies
  • March 21, 2023
Chris Hackett wrote:

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

No, currently its still now working


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings