cancel
Showing results for 
Search instead for 
Did you mean: 

Creating and populating field on Purchase order B1UP

former_member606556
Discoverer
0 Kudos

Hi Everyone,

Im new to B1 and B1UP, i am just wondering how i would go about creating a new field on all purchase orders that displays the corresponding vendors PO balance from the Business Partner master data . (Running on a HANA db)

Please see the attached image

Thanks everyone for the help !

Accepted Solutions (1)

Accepted Solutions (1)

kvbalakumar
Active Contributor

Hi,

In order to have the PO Balances at all POs,

  • Please first create a B1 Validation Configuration based on CardCode field at PO.
  • Create a Universal Function of type Macro and use Set command to set the value at PO.

Use the below macro command

Set(POBalancefield|SQL:SELECT "OrderBalFC" FROM OCRD WHERE "CardCode" = $[$4.0.0]);

Refer this link for some useful Boyum B1UP samples.

Regards,

Bala

Answers (0)