Sales order - Bussiness Central

[IzabEwa]

I am trying to create an app that's connected to Business Central , and the purpose of the app is basically to do, edit and view Sales Orders. Sales order is composed out of two tables : Sales Header and Sales Lines. I have put them two be in two edit forms, however when I submit forms I keep getting errors. Is it possible to get it to work in PowerApps? 

[Bilakanti]

@IzabEwa , It's showing that Document No. which is required field is been passed as Blank, and hence creation process is getting failed.

[IzabEwa]

1. Sales Header table 

2. sales line table 

 save button 

SubmitForm(Form1) & SubmitForm(Form3)

[IzabEwa]

do you know why it's doing that , since I have filled it out?

[Nogueira1306]

What error does it give you in the button?

Also, is the form mode set to New?

[IzabEwa]

the button gives the error that I've attached previously .

both forms are set to new  

[Nogueira1306]

It says that the document number must have a number, since it does not has one, it says it is a bad request

[IzabEwa]

I have set the document number , hence I'm not sure why the error is there. 

[Nogueira1306]

Not sure because I dont work with BC. But, is that number automatic? I yes, why set it?
Plus, you can always try to write on the sql and then have a button on Nav to refresh SQL and get it

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira