Balance Forward

sperron

Member
Hi helpers,

I am trying to make a variable for " Balance Forward " in the special customer statement report, before list the invoices and the credit momos I would like to have the balance forward before the date user put in the PO for the start date.

I use the report design in the B7332 One World

What are the steps to perform it ? Could you explain me by a example ?

I'm sorry for my english language but I'm french people

Thanks a lot for give me some help !!!!

Financial RDA
 

franck_blettner

Active Member
Bonjour,

Je vais te parler en français ce sera plus simple pour nous deux, je
m'excuse auprès des autres personnes ne parlant pas français.
Pour retrouver le solde du client à une date donnée, tu peux essayer
d'utiliser la business fonction B03B0137.
Il suffit que tu appelles cette fonction dans les Event-Rules de ton Report
dans l'événement Do Section. Par contre je ne sais pas si elle marche
correctement, je n'ai pas essayé, mais si tu as des problèmes pour t'en
servir je ferais le test.

Franck BLETTNER
Service Informatique RAVATE
Tel : 02 62 90 40 63
E-mail : [email protected]


PS : Paramètres de la function :

B03B0137
F03B11 As Of Aging Summary

Purpose
To take a customer number and company and recalculate the amounts listed
below as output, to the value that they were at the date that is input in
the jdDateAgeAsOf.

Setup Notes and Prerequisites

Special Logic

Technical Specifications

Parameters
Data Item Description I/O Required Notes
AN8 mnAddressNumber I Y
CO szCompany I Y
DAG jdDateAgeAsOf I Y
AGEM cAgingMethod I Y
AGE cBaseAgingDate I Y
CRDY mnAgingDaysARCurrent I
AGR1 mnAgingDaysAR001 I
AGR2 mnAgingDaysAR002 I
AGR3 mnAgingDaysAR003 I
AGR4 mnAgingDaysAR004 I
AGR5 mnAgingDaysAR005 I
AGR6 mnAgingDaysAR006 I
AGR7 mnAgingDaysAR007 I
AAP mnAmountOpen O
PDA mnAmountPastDue O
FTR mnAmountFuture O
CURR mnCurrentAmountDue O
AG1 mnAmtAgingCategories1 O
AG2 mnAmtAgingCategories2 O
AG3 mnAmtAgingCategories3 O
AG4 mnAmtAgingCategories4 O
AG5 mnAmtAgingCategories5 O
AG6 mnAmtAgingCategories6 O
AG7 mnAmtAgingCategories7 O
CRCD szCurrencyCodeFrom I If currency ON
OINV mnNumberOfOpenInvoices O
OCB mnOpenChargebackAmount O
NOCB mnNuberOfOpenChargebacks O
ADSC mnAmtDiscountAvailable O
EDSC mnDiscountEarnable O
PDIN mnNuberOfPastDueInvoices O
OCBP mnChargebackPastDue O
DSCP mnDicountAvailablePastDue O
CUIN mnNumberOfCurrentInvoices O
OCBC mnCurrentChargebackAmount O
CUDS mnCurentDiscountAvailable O
CUED mnCurrentDiscountEarnable O
UAA mnAmountUnapplied O
NUR mnNumberOfUnappliedReceipts O
CREE mnCreditsEntered O
CREN mnNumberOfOpenCredits O
ODAM mnOutstandingDraftAmount O
NOD mnNumberOfOpenDrafts O
DDOA mnClaimAmountOpen O
DDNB mnNumberOfOpenClaims O
ISTC cARPostToCashManagement I Y

-----Message d'origine-----
De : [email protected] [mailto:eek:[email protected]]De la
part de sperron
Envoyé : mardi 23 octobre 2001 15:45
À : [email protected]
Objet : Balance Forward


Hi helpers,

I am trying to make a variable for " Balance Forward " in the special
customer statement report, before list the invoices and the credit momos I
would like to have the balance forward before the date user put in the PO
for the start date.

I use the report design in the B7332 One World

What are the steps to perform it ? Could you explain me by a example ?

I'm sorry for my english language but I'm french people

Thanks a lot for give me some help !!!!

Financial RDA
--------------------------


Franck BLETTNER
Service Informatique RAVATE
Tel : 02 62 90 40 48
E-mail : [email protected]
 

Sef

VIP Member
Bonjour "sperron"

Je voudrais te parler en Français, mais ce sera plus difficile pour moi; je m'excuse auprès des autres personnes ne parlant pas Anglais.

;-) Just a joke, no offence meant ;-)

Depending on your report (are you modifying the statement report or writing a report from scratch?) you could create a section which is called prior to the main reporting section (eg at the level break header). In this section (which is hidden) you perform the required accumulations with dates PRIOR to your processing Option date. These values you can display at the beginning of each group (eg customer).

Bon chance et Rgds,



Sef van den Nieuwelaar
Australia
B732 on NT, XE on NT, B732/A73 on AS400, B733 on NT
 
Top