PJM - Financial Overview - Cost Type Scope

SUGGESTED

The financial follow-up of the PJM module claims to be prepared to represent outputs of other modules of the system, from purchases and sales movements typed with the type of cost present in the article or DEFAULT if it has no registered, time management, expense notes, also type of cost.

However in the case of invoices from third-party suppliers and third-party customers, the same does not happen since the system can not type the cost type and puts everything in the same place. From a management point of view it does not make any sense in the other modules to be able to typify each movement and in these cases not to be. The rule should be the same.

The queries used by this structure, if we look closely, invoke a PCCCOD field that does not exist in any of the business partner tables. The manual itself describes that financial costs are considered by the cost type defined for the entire query and not in a field that does not even exist.

This problem was presented to Sage, which considers that it should be submitted as a suggestion for improvement, however in our view this is a module design error.

My client considers that everything can not be analyzed as being the same cost if it is not and requires a similar option as the rest.

Anyone else agree or have the same problem?

  • 0

    Hi, we had the same issue  to resolve we setup statistical code to match the cost type and  changed the SQL query to use the statistical code for cost type.

  • 0 in reply to ccohen

    Hi. Could you send me an example of what you did to solve the problem? I tried to put a PCCCOD field in the tables and screens of the third party invoices to identify the movements since the query already existed, however I got error at the level of the class.

    An example would be excellent for helping me to resolve this issue. My problem is with query PJM018 for example.

    Thank you

  • 0 in reply to Ruben Anjos
    SUGGESTED

    I changed the query type in query setup to  to time entry and changed  the query as per below, if you need screenshots please send me your email and I will forward 

    added CASE WHEN B.STT1_0= ' ' THEN 'DEFAULT' ELSE B.STT1_0 END, 

     

    SELECT

    L.OPPNUM_0,

    L.TASCOD_0,

    L.PBUCOD_0,

    L.PIMNUM_0,

    CASE WHEN B.BPRLIN_0 = ' ' THEN S.BPR_0 ELSE B.BPRLIN_0 END,

    CASE WHEN B.BPRLIN_0 = ' ' THEN (SELECT P.BPRNAM_0 FROM BPARTNER P WHERE P.BPRNUM_0 = S.BPR_0) 

    ELSE (SELECT P.BPRNAM_0 FROM BPARTNER P WHERE P.BPRNUM_0 = B.BPRLIN_0)  END,

    S.ACCDAT_0,

    B.QTY_0,

    B.AMTNOTLIN_0,

    S.CUR_0,

    S.CURTYP_0,

    S.RATMLT_0,

    S.NUM_0,

    ' ',

    B.FCYLIN_0,

    CASE WHEN B.STT1_0= ' ' THEN 'DEFAULT' ELSE B.STT1_0 END,

    CASE WHEN B.BPRLIN_0 = ' ' THEN (SELECT P.BPRNAM_0 FROM BPARTNER P WHERE P.BPRNUM_0 = S.BPR_0) 

    ELSE (SELECT P.BPRNAM_0 FROM BPARTNER P WHERE P.BPRNUM_0 = B.BPRLIN_0)  END,

    S.ACCDAT_0,

    ' '

    FROM PINVOICE S, BPSINVLIG B, PIMPL L      

    Where S.NUM_0 = B.NUM_0

    AND B.INVTYP_0 = 1

    AND B.PJTLIN_0 = L.PIMNUM_0

    AND L.PIMNUM_0 IN (SELECT PIMNUM_0 FROM PIMPLSEL WHERE PIMSSS_0 = %1%)

  • 0 in reply to ccohen

    Thank you :) Have you tried with some field that was not original? Could you send what you have and who can help to [email protected]? Thank you so much again!