cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IzabEwa
Helper IV
Helper IV

Sales order - Bussiness Central

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? 

17 REPLIES 17
Bilakanti
Impactful Individual
Impactful Individual

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

1. Sales Header table 

2. sales line table 

 save button 

SubmitForm(Form1) & SubmitForm(Form3)

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

What error does it give you in the button?

Also, is the form mode set to New?

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

both forms are set to new  

Nogueira1306_0-1629716388292.png

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

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

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,309)