First post on this site. Inherited a OneWorld Xe environment on Microsoft SQL Server. Need to pull in via SQL query from F0006 F0901 F0902. Anyone have this query available to read in balance sheet and P&L data? Basically trying to do an M&A financial roll-up to a new company defined in another ERP.
We have a scenario where an old PO with multiple receipts were matched with incorrect quantities. The vouchers have been paid and hence ineligible for reversal.
Now, because of incorrect quantities the receipt lines are still open with pending RNV. Also while trying to voucher match there...
With as much overseas sourcing as there is today, I figured there must be JDE E1 best practice for setting up items that are both manufactured and purchased. I'm interested in learning how other businesses handle this issue. I have yet to find a solid solution that works seamlessly throughout...
We are facing a issue related to monthly closing. Every month it's delayed due to.
1) The collectors continue to bring receipts after the cutoff date with previous month check date.
Since the collections are huge in size and there are lot of customers it is so far difficult to zero this...
I created one custom sales report want Aging data of Customer in header of the report like Credit balance, Over Credit Limit, Credit Limit, 31-60, 61-90, 91-120 etc.. (This data is available in P40250 application)
I fetched credit limit from customer master and the rest of the field I tried to...
Where from I can get overview (diagram, flow charts, pictures etc) of the following modules,
In procurement, Order Request comes first. Quote Order second. Then Purchase Order etc.