I'm trying to archive the Billing tables, and in particular, the BI_HDR_VAT table. As it does not register as a child of the BI_HDR table, I tried to have my archive query join to the BI_HDR table, so that the parameters used for archiving the BI_HDR table, would be the same for the BI_HDR_VAT table.
Unfortunately, this is not working as I receive a unique constraint error.
How would I go about archiving this table, as the dates on the BI_HDR_VAT table do meet the parameters used when archiving the other Billing tables.
I would like to understand the table PS_VCHR_ACCTG_LINE - Can anyone let me know which component updates this table or which app. engine (or sqr updates) this table, esp. the fields - ACCOUNTING_PERIOD and FISCAL_YEAR
Actually I am creating an asset thru AP/PO Interface (and as part of this process, ran Voucher Match, Doc Tol & Voucher Post also, followed by INTFAPAM, AMPS1000, AMIF1000 and successfully added the asset), then created accounting entries using AM_AMAEDIST, and generated journals using FS_JGEN, and when I try to query this table (PS_VCHR_ACCTG_LINE), most of the fields are updated, except these two fields - Accounting Period, and Fiscal Year
I also successfully Posted the Journal, but again the Journal ID, Journal Line, and Journal Date fields in PS_VCHR_ACCTG_LINE aren't updated
Can anyone kindly let me know why or what has to be done to see value in the fields - 1. Accounting Period 2. Fiscal Year 3. Journal ID 4. Journal Date, and 5. Journal Line
As far as the VCHR_ACCTG_LINE table it is updated by Voucher Post process and when you run the Journal Gen process it will update the table with Journal fields.
Hi We are on PS Fin 9.2 & PT 8.53 I have a question in Asset Management -
I am new to Asset mgmt & would like to know - 1. When will an asset be considered as "Fully Depreciated" 2. What are the tables in which I can see this status as Fully Depreciated 3. Suppose I had added an asset thru AP/PO Interface, and also run depr. calc, then what is the process to make the asset status to "Fully Depreciated" ?
Would like to know if there is any delivered report SQR or any batch process to know the status of an asset.
I mean, the requirement is something like this -
I have to create a new requisition, for e.g., for a laptop. However, before I create a requisition, I would like to know if there are any available laptops, (for e.g. if an employee has left the organization and his laptop has not been assigned to any other employee), then in that case, instead of creating a new requisition and later cancelling the requisition, i would like to know if there are any delivered sqr process or any app. engine process, which when run, will give me a list of such assets
If I have to create a custom report/process, what are the tables I need to refer to?
Hi
ReplyDeleteWe are using PS8.8 & PT8.47
I'm trying to archive the Billing tables, and in particular, the BI_HDR_VAT table. As it does not register as a child of the BI_HDR table, I tried to have my archive query join to the BI_HDR table, so that the parameters used for archiving the BI_HDR table, would be the same for the BI_HDR_VAT table.
Unfortunately, this is not working as I receive a unique constraint error.
How would I go about archiving this table, as the dates on the BI_HDR_VAT table do meet the parameters used when archiving the other Billing tables.
Thanks
hi please keep on posting useful tips.....for PS 9.0 Financials specially for O2C. It has really helped me. Thanks a lot :)
ReplyDeleteHi
ReplyDeleteWe are on PS Fin 9.2, and PT 8.53
I would like to understand the table PS_VCHR_ACCTG_LINE -
Can anyone let me know which component updates this table or which app. engine (or sqr updates) this table, esp. the fields - ACCOUNTING_PERIOD and FISCAL_YEAR
Actually I am creating an asset thru AP/PO Interface (and as part of this process, ran Voucher Match, Doc Tol & Voucher Post also, followed by INTFAPAM, AMPS1000, AMIF1000 and successfully added the asset), then created accounting entries using AM_AMAEDIST, and generated journals using FS_JGEN, and when I try to query this table (PS_VCHR_ACCTG_LINE), most of the fields are updated, except these two fields - Accounting Period, and Fiscal Year
I also successfully Posted the Journal, but again the Journal ID, Journal Line, and Journal Date fields in PS_VCHR_ACCTG_LINE aren't updated
Can anyone kindly let me know why or what has to be done to see value in the fields -
1. Accounting Period
2. Fiscal Year
3. Journal ID
4. Journal Date, and
5. Journal Line
As far as the VCHR_ACCTG_LINE table it is updated by Voucher Post process and when you run the Journal Gen process it will update the table with Journal fields.
DeleteHi Thanks
ReplyDeleteHi
ReplyDeleteWe are on PS Fin 9.2 & PT 8.53
I have a question in Asset Management -
I am new to Asset mgmt & would like to know -
1. When will an asset be considered as "Fully Depreciated"
2. What are the tables in which I can see this status as Fully Depreciated
3. Suppose I had added an asset thru AP/PO Interface, and also run depr. calc, then what is the process to make the asset status to "Fully Depreciated" ?
Thanks in advance
Hi Experts
ReplyDeleteWe are on PS Fin 9.2 and PT 8.53
Would like to know if there is any delivered report SQR or any batch process to know the status of an asset.
I mean, the requirement is something like this -
I have to create a new requisition, for e.g., for a laptop.
However, before I create a requisition, I would like to know if there are any available laptops, (for e.g. if an employee has left the organization and his laptop has not been assigned to any other employee), then in that case, instead of creating a new requisition and later cancelling the requisition, i would like to know if there are any delivered sqr process or any app. engine process, which when run, will give me a list of such assets
If I have to create a custom report/process, what are the tables I need to refer to?
Thanks
Guru R