logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
ksturm@easy-automation.com  
#1 Posted : Monday, July 28, 2025 8:35:30 PM(UTC)
ksturm@easy-automation.com

Rank: Member

Groups: Registered
Joined: 3/21/2024(UTC)
Posts: 11
United States

I have a few questions largely with respect to Payments Terms on Customers and Vendors and how they impact Terms on A/P and A/R Invoices. Any and all help is greatly appreciated!

* POST A/R Invoice
** When creating an A/R (Customer) Invoice via the API, will the Terms get set using the Customer's Payment Terms, if not specified in the request?
** If the Customer has no Payment Terms set, is there a default Terms that will be used, if not specified in the A/R API request?
** If we specify the "Date" on an A/R Invoice request, will the API calculate/set the Due/Discount dates using the Terms on the Invoice?
* POST Customer
** Is there a system setting/preference for the default Payment Terms for a Customer? We're wondering if we would need a setting on our end to store a default Payment Terms and send that with each customer or if it would be set in the CPA API if we do not specify it.
* POST A/P Invoice
** When creating an A/P (Vendor) Invoice via the API, will the Terms get set using the Vendor's Payment Terms, if not specified in the request?
** If the Vendor has no Payment Terms set, is there a default Terms that will be used, if not specified in the A/P API request?
** If we specify the "Date" on an A/P Invoice request, will the API calculate/set the Due/Discount dates using the Terms on the Invoice?
* POST Vendor
** Is there a system setting/preference for the default Payment Terms for a Vendor? We're wondering if we would need a setting on our end to store a default Payment Terms and send that with each customer or if it would be set in the CPA API if we do not specify it.
tony  
#2 Posted : Tuesday, July 29, 2025 12:50:33 PM(UTC)
tony

Rank: Advanced Member

Groups: Registered
Joined: 2/28/2018(UTC)
Posts: 79
United States
Location: Pennsylvani mostly

Was thanked: 9 time(s) in 9 post(s)
In v20, which is supposed to be released shortly, the terms information is being set.

In v19.5, we weren't doing that yet. I'll follow up with the logic for customer and vendor payments* after I do some research.

* Edit: meant invoices

Edited by user Tuesday, July 29, 2025 1:23:59 PM(UTC)  | Reason: Not specified

tony  
#3 Posted : Tuesday, July 29, 2025 1:22:23 PM(UTC)
tony

Rank: Advanced Member

Groups: Registered
Joined: 2/28/2018(UTC)
Posts: 79
United States
Location: Pennsylvani mostly

Was thanked: 9 time(s) in 9 post(s)
First the A/P side. This is what the change notes say:

Allow the terms to be set on an invoice.
If the terms are not set, then set the terms to the default for the vendor, if any.
If the discount date is set, use that date regardless. If the discount date is not set, use the discount date calculated based on the terms.
If the due date is set, use that date regardless. If the due date is not set, use the due date calculated based on the terms.
ksturm@easy-automation.com  
#4 Posted : Tuesday, July 29, 2025 1:24:20 PM(UTC)
ksturm@easy-automation.com

Rank: Member

Groups: Registered
Joined: 3/21/2024(UTC)
Posts: 11
United States

We will be getting into the POSTing of Customers, Vendors, A/P, and A/R Invoices over the next two weeks. As we learn more I will refine my questions and update what we find out. It sounds like we will be interested in using v20.
tony  
#5 Posted : Tuesday, July 29, 2025 2:06:35 PM(UTC)
tony

Rank: Advanced Member

Groups: Registered
Joined: 2/28/2018(UTC)
Posts: 79
United States
Location: Pennsylvani mostly

Was thanked: 9 time(s) in 9 post(s)
The customer invoice works the same as the A/P invoice.

Now to answer the questions:

* POST A/R Invoice
** When creating an A/R (Customer) Invoice via the API, will the Terms get set using the Customer's Payment Terms, if not specified in the request? Yes.
** If the Customer has no Payment Terms set, is there a default Terms that will be used, if not specified in the A/R API request? No.
** If we specify the "Date" on an A/R Invoice request, will the API calculate/set the Due/Discount dates using the Terms on the Invoice? Yes.

* POST Customer
** Is there a system setting/preference for the default Payment Terms for a Customer? We're wondering if we would need a setting on our end to store a default Payment Terms and send that with each customer or if it would be set in the CPA API if we do not specify it. There is no default for a new customer. However, I'd suggest setting up a default customer (we call it a "template customer") and then setting the templateId field to the template customer's ID

* POST A/P Invoice
** When creating an A/P (Vendor) Invoice via the API, will the Terms get set using the Vendor's Payment Terms, if not specified in the request? Currently, no. In v20, yes.
** If the Vendor has no Payment Terms set, is there a default Terms that will be used, if not specified in the A/P API request? No.
** If we specify the "Date" on an A/P Invoice request, will the API calculate/set the Due/Discount dates using the Terms on the Invoice? Yes.

* POST Vendor
** Is there a system setting/preference for the default Payment Terms for a Vendor? We're wondering if we would need a setting on our end to store a default Payment Terms and send that with each customer or if it would be set in the CPA API if we do not specify it. No, but you can specify a template vendor to use via the templateId field like you can for the customer

As long as I'm messing around on this, I'll add my three greatest frustrations trying to test this so you can, hopefully, avoid them:

1. The logic for opening new periods in CenterPoint is tied to the U/I. Almost every time I try to test, I get a message about a period not being open. To fix it, I go into CenterPoint and open any transaction screen and enter a date in the future. Today, for example, I got the error again and had to open up BusinessSample in CenterPoint, go to a transaction screen (Sales Orders) and enter 12/31/2025.
2. When creating customer invoices, you can get an "empty error" when the customer's credit limit is exceeded. So today, I had to open up the customer and set a high credit limit. This is only a problem in Business, I believe. And I think you can turn of credit limit checks in Preferences.
3. CenterPoint has verticals (e.g. Ag, Business, etc.) The API is going to assume the vertical is the one you installed last which can lead to "this database was created with another product" errors and makes testing against multiple verticals a burden. If this will be a problem for you, let me know.

Also, I ran tests today against BusinessSample - to prepare, I had to enter 12/31/2025 in a transaction screen's date field to open periods for the year. I also made "Alpine, Inc" a customer by going into Names maintenance and checking the "Is Customer" box. Then I went into Customer maintenance and set Alpine's credit limit to 9000 and set their terms to Net30. I also went into Vendor maintenance and set their A/P terms to Net30 too.

My A/P Test DTO for the Business vertical using the sample database BusinessSample was

Code:

{
  "companyId": 2147470000,
   "vendorId": 2147469996,
   "date": "8-1-2025",
   "invoiceNumber": "10003",
   "lines": [
      {
        "salesItemId": 2147470000,
        "quantity1": 1,
        "unitCost": 102,
        "notation": "testing vendor's default terms"
      }
  ]
}


My A/R Test DTO was

Code:

{
  "companyId": 2147470000,
   "customerId": 2147469996,
   "date": "8-1-2025",
   "invoiceNumber": "10003",
   "lines": [
      {
        "salesItemId": 2147470000,
        "quantity": 2,
        "unitprice": 200,
        "notation": "testing customer's default terms"
      }
  ]
}


The return value will show the discount and due date calculated based on the Net30 terms in both cases. I didn't do the calculation myself to verify, but I did check against what the UI in CenterPoint calculated.

Edited by user Tuesday, July 29, 2025 2:17:31 PM(UTC)  | Reason: Set colors on reply text, inadequate proofreading

ksturm@easy-automation.com  
#6 Posted : Wednesday, July 30, 2025 9:26:02 PM(UTC)
ksturm@easy-automation.com

Rank: Member

Groups: Registered
Joined: 3/21/2024(UTC)
Posts: 11
United States

Thanks, Tony! That information will help us tremendously.
Users browsing this topic
Guest (2)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.