Advance ATP Check in SAP Business One

[piccolinet]

Hi Dears,

Is it possible to call Advance ATP check in DI API or ?

Thank you in advance

[Johan_H]

Hi Marcelo,

The ATP is built into the client. In other words the B1 client runs a number of queries and calculations, and shows the outcome in the ATP window.

In the DI API you cannot call the ATP, because it is not in itself an object/interface. To achieve what you want, you will need to figure out what those queries and calculations are, and then create your own addon to reproduce them.

With MS SQL Server you can run a trace in the SQL Server Profiler to find out what queries B1 runs when you use the ATP. I do not know if HANA has a similar tool.

Regards,

Johan

[piccolinet]

Hi Geison

you have one code sample , why i can do it?

thanks
Obrigado
Marcelo

[geison_correa]

Hi Marcelo,
We have the same problem.
We need to run ATP in batch mode.
Did you get anything back?

[piccolinet]

Hi

Any news

[piccolinet]

Hi Dears,

Thank you for your feedback.

Yes, correct we want to use Advance Available to promise in SAP B1 Hana.

We have more than one warehouse but in ATP Checking Role we cannot include or exclude some warehouse(only check based on Sales order warehouse).

Also, we cannot use only one warehouse

Now we decide after receiving sales order if system cannot assign Delivery Schule for sales order(base on sales order warehouse) we create one transfer request from another warehouse to sales order warehouse and then system based on this transfer request can assign delivery Schule, but after create transfer request again we must run availability check. We want run this availability check in background with DI API or …, is it possible or not?

Thank you in advance

Best Regards.

[ANKIT_CHAUHAN]

Hi Marcelo Luis Piccoli,

Can you please explain in details along with one or two screenshots what exactly you are trying to achieve?

Are you referring to Available to Promise or I am getting it wrong?

Kind regards,

ANKIT CHAUHAN

SAP Business One Support