Description |
Release 15.2.0818.521
|aptrx_vnd_no|aptrx_ivc_no|aptrx_sys_rev_dt|aptrx_sys_time|aptrx_cbk_no|aptrx_chk_no|aptrx_trans_type|aptrx_batch_no|aptrx_pur_ord_no|aptrx_po_rcpt_seq|aptrx_ivc_rev_dt|aptrx_disc_rev_dt|aptrx_due_rev_dt|aptrx_chk_rev_dt|aptrx_gl_rev_dt|aptrx_disc_pct|aptrx_orig_amt|
|SHELL |45435435|20150817|103519|1| |I|2|4365346|1|20150723|20150723|20150723|0|20150723|0|20632.5
|
|apegl_cbk_no|apegl_trx_ind|apegl_vnd_no|apegl_ivc_no|apegl_dist_no|apegl_alt_cbk_no|apegl_gl_acct|apegl_gl_amt|apegl_gl_un|A4GLIdentity|
|1|I|SHELL |45435435|1|1|652550.00006001|125|0|624|
|1|I|SHELL |45435435|2|1|652550.00006001|-125|0|626|
|1|I|SHELL |45435435|3|1|550000.00001001|17745|7500|628|
|1|I|SHELL |45435435|4|1|220085.00000000|1372.5|0|630|
|1|I|SHELL |45435435|5|1|220080.00000000|1425|0|632|
|1|I|SHELL |45435435|6|1|220085.00000000|7.5|0|634|
|1|I|SHELL |45435435|7|1|220082.00000000|22.5|0|636|
|1|I|SHELL |45435435|8|1|220083.00000000|60|0|638|
Requirements:
* apegl_gl_un should import in when importing bills from origin
* this is required so that the customer can determine unit margins in the financial statement
* we need script to update already import invoices
** Bill Detail
** GL Detail
Suggestion:
* Change ordered and received to 7500
* Recalculate Cost based on total of gl entry
** 17,745/7500 = 2.366
!pastedImage_d42127_0.png!
|