Sef
VIP Member
One of the challenges when using the ST/OT process for sales transfers is to reconcile the “Stock in Transit” account.
Theoretically when no open ST or OT orders exist, this account should have a zero balance. However for a variety of reasons this never seems to be the case.
Changes in costs, incorrect cost methods, receipting OT before shipping ST (yes, this is still possible in standard JDE!), missing links between ST and OT can cause integrity issues that are hard to trace.
A possible solution is the usage of flex accounting. In order to take full advantage I suggest the following setup:
1) Enable flex accounting:
Select P16902 in G1631 and add two ‘FA’ records: F4311 in P4312 and F4211 in R42800 (the latter is included in standard JDE)
Also add two ‘SM’ records: One for P4312 and one for R42800. I normally select setup method ‘C’ to allow flex accounting by AAI as well as account no.
2) Activate flex accounting in the processing options of R42800 and P4312
3) Set the Posting edit code of the Stock in transit account to 'S'. This will force the existence of a valid subledger (in the proposed setup it validates the existence of the related order number in F4211, a problem which was very common in older versions).
4) Add Flex rules
Select P40296 in G4241)
For ST : Enter Company number(s), Object account No (‘from‘ and ‘to’ can both be the same and equal to your Stock in Transit account), Document type = ‘ST’, Subledger type = ‘Y’, mark the SL column with an ‘X’ , File name = 'F4211' and Data item = ‘RORN’
For OT: Enter Company number(s), Object account No (‘from‘ and ‘to’ can both be the same and equal to your Stock in Transit account), Document type = ‘OT’, Subledger type = ‘Y’ (this will put leading zero’s in front of the document number), mark the SL column with an ‘X’ , File name = 'F4311' and Data item = ‘DOCO’
Et voila, the set up is complete
Just one footnote: Flex accounting for AAI 4320 does not work in versions prior to B7332. SAR 4053994 needs to be applied/retrofitted.
Sef van den Nieuwelaar
Australia
B732 on NT, XE on NT, B732/A73 on AS400, B733 on NT
Theoretically when no open ST or OT orders exist, this account should have a zero balance. However for a variety of reasons this never seems to be the case.
Changes in costs, incorrect cost methods, receipting OT before shipping ST (yes, this is still possible in standard JDE!), missing links between ST and OT can cause integrity issues that are hard to trace.
A possible solution is the usage of flex accounting. In order to take full advantage I suggest the following setup:
1) Enable flex accounting:
Select P16902 in G1631 and add two ‘FA’ records: F4311 in P4312 and F4211 in R42800 (the latter is included in standard JDE)
Also add two ‘SM’ records: One for P4312 and one for R42800. I normally select setup method ‘C’ to allow flex accounting by AAI as well as account no.
2) Activate flex accounting in the processing options of R42800 and P4312
3) Set the Posting edit code of the Stock in transit account to 'S'. This will force the existence of a valid subledger (in the proposed setup it validates the existence of the related order number in F4211, a problem which was very common in older versions).
4) Add Flex rules
Select P40296 in G4241)For ST : Enter Company number(s), Object account No (‘from‘ and ‘to’ can both be the same and equal to your Stock in Transit account), Document type = ‘ST’, Subledger type = ‘Y’, mark the SL column with an ‘X’ , File name = 'F4211' and Data item = ‘RORN’
For OT: Enter Company number(s), Object account No (‘from‘ and ‘to’ can both be the same and equal to your Stock in Transit account), Document type = ‘OT’, Subledger type = ‘Y’ (this will put leading zero’s in front of the document number), mark the SL column with an ‘X’ , File name = 'F4311' and Data item = ‘DOCO’
Et voila, the set up is complete
Just one footnote: Flex accounting for AAI 4320 does not work in versions prior to B7332. SAR 4053994 needs to be applied/retrofitted.
Sef van den Nieuwelaar
Australia
B732 on NT, XE on NT, B732/A73 on AS400, B733 on NT
