Revenues and Payments MFG questions

Ufin

New Member
Hi Guys and MFG/PRO Gurus. I have several question regarding Revenues/Procurement/Disbursement. I am former user of SAP and now I am trying to get a little understanding of this new (at least for me) ERP. It is possible that some questions would not be relevant for MFG/PRO, because are based on my understanding of SAP. Any help would be appreciated.


1. Is in some MFG/PRO table a type for Invoices (how can I distinguish between direct, indirect and other)
2. Is there any report/ field in table (e.g. sales orders) which can I use for calculation Net and Gross Sales and the difference between them?
3. In which MFG table can I obtain standard price for products/purchased good (I supposed it is pc_mstr - Price list master but this table is blank)? I want to compare standard price and actual price from purchase order as well as for sales orders.
7. When I want a list of all purchase orders, is my approach of linking pod_det and po_mstr (using po_nbr) correct or any additional constraint have to be applied?
8. Is in some MFG/PRO table/field identification of payment method (cash,cheque, wire transfer,…)? And is it possible to identify petty cash payment?
9. When I want a list of all Good Receipts, is my approach of linking prh_hist and pod_det (records where prh_hist and prh_line is the same in both tables)?
10. When I want a list of all payments to suppliers, is my approach of linking ap_mstr, ck_mstr and ckd_det correct? I have also applied additional constraint ap_type=CK
11. Is there any field in MFG/PRO table with Reason code or description for issuing credit note.
 
Hi There,

1. No that I know of. However you would use different Sales Order sequencing for direct/indirect SO's or would flag indirect SO's in a custom field.
2. Yes, in 7.15 menu.
3. idh_hist table, idh_price is your actual net price, idh_list_pr is your list (STD) price. However both of these fields could be overwritten if setup allows users to. To get to the price I'd suggest to run 1.10.1.13 inquiry.
7. correct.
8. do not know.
9. I think so.
10. correct. I'd suggest you to download entity diagram PDF from QAD support site and double check table relationships.
11. reason codes are defined in 36.2 menu, yes QAD has dedicated table for this.

Regards

Alex Kim
32 Soft Inc
Excel Data Loaders
 
Thank you for your answers:
question 11: ok thanks for the report, what is the name of the table pls?

One more question, sod_det - sod_qty_ship stands for quantity to be shipped or quantity already shipped? I ask because how can I distinguish between SO that have been already shipped or not?
Thanks in advance
 
Back
Top