Small and medium business | Business Central, N...

Purchase Invoice created in a Page Api call sets wrong values in field

(0) Share

Report

Posted on by chigivigi

I have a Purchase Invoice Page API that runs in my demo tenant sandbox environment. I have set it to use Document Date and Due Date fields. When I create a new purchase invoice using those fileds it fills them with wrong values.

The Due Data field gets the Document Date field value, and the Document Date sets the current date as the value.

If I try to update those two fields to correct values, then It just uses the Document Date value to for both fields.

When I repeat the patch action for the second time with the same values, only then are the Due Date and Document Date fileds correct.

All the actions are done in Postman.

How can I force the request to fill the fields with correct values?

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi chigivigi ,

When you created a new Purchase invoice, system always takes Posting Date, document date and due date as system defaults workdate, I am not sure how your api is working when you are creating a new Purchase invoice and how its filling all this date

Can you please more describe it?

Thanks.

Was this reply helpful? Yes No
chigivigi 77 on at

Like (0)

Report

I am passing the Document Date and Due Date in the body as string values (YYYY-MM-dd). I create a post action in postman and set the body as a raw JSON.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi chigivigi ,

Are you using the Patch command?

Where you are passing the Purchase Invoice No.?

Thanks.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Also please check below image, you are taking both places a Document Date, it that correct?

Was this reply helpful? Yes No
chigivigi 77 on at

Like (0)

Report

I apologize, I put the wrong value inside the body. I am using the pot command.

This is the command:

This is the Patch Command:

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi,

When you first entering the Document date, system is calculating the Due date based on the Payment terms attached with vendor card and putting the same value in Due date, its means its validating the Document Date field's trigger code.

Thanks.

Was this reply helpful? Yes No
chigivigi 77 on at

Like (0)

Report

Is that also the reason that the Document Date fields uses the current Date as the value?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Yes, its validating the Document Date field's code.

Was this reply helpful? Yes No
chigivigi 77 on at

Like (0)

Report

Thank you for your help.

Was this reply helpful? Yes No