cancel
Showing results for 
Search instead for 
Did you mean: 

Does SAP B1 PLD Have a Hidden Business Partner Code for Account Balance?

patrice_vigier
Participant
0 Kudos
100

SAP B1 v10

Hello,

I'm creating a custom layout for Account Balance in SAP Business One Print Layout Designer, and I noticed that two text fields display the customer name and customer account number, but they do not reference any database field.

Here is the data for these fields:

Field 1 (Customer Name)
- Unique ID: `F_021`
- Field Type: `Text`
- Link To: (Nothing)*
- Source Type: `Free Text`

Field 2 (Customer Account Number)
- Unique ID: `F_022`
- Field Type: `Text`
- Link To: (Nothing)*
- Source Type: `Free Text`

Despite being Free Text fields, `F_021` correctly outputs the customer name, and `F_022` correctly outputs the customer account number.

My Questions:*
1. How is SAP B1 PLD retrieving this data if these fields are set as Free Text?
2. Does SAP B1 internally map `F_021` and `F_022` to the Business Partner (`OCRD.CardCode`)?
3. Is there a hidden variable or system function that automatically fills these values?
4. How can I manually reference these fields if I want to use them elsewhere?

Any insights would be greatly appreciated!

Thank you!

View Entire Topic
williamwachholz
Active Participant

Hello,

 

Answering all your questions: these are System Variables mapped by the ID, so you just need to set the ID with the corresponding value and the internal logic of PDL will fill it, for example:

Document Header Variables:

F_021: CardCode (Business Partner Code)
F_005: DocNum (Document Number)
F_002: DocDate (Document Date)
F_004: DocDueDate (Due Date)
F_007: NumAtCard (Customer/Vendor Reference Number)
F_024: CardName (Business Partner Name)
F_025: ContactPerson (Contact Person)
F_043: Comments (Remarks)
F_042: DiscountPercent (Discount %)
F_014: DocTotal (Document Total)
F_037: DocCurrency (Document Currency)
F_016: TaxSum (Tax Total)
F_039: DocTime (Document Time)
F_166: DocStatus (Document Status)

 

Best regards

patrice_vigier
Participant
0 Kudos

Hello,
Thank you williamwachholz but this does not answer my question.
Sincerely

patrice_vigier
Participant
0 Kudos

I know how to link a system variable to a PLD ID (F_xxx), I mention in my post that I have F_xxx that returns values but there is no visible system variable linked to them and I would like to know why.