Skip to Content
author's profile photo Former Member
Former Member

Field BoeType - OBOE

Hi, I need your help,

What does Boetype field mean into Table OBOE? The results are I or O, but I don't know when it's used those values.

Thanks!!!!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2008 at 09:24 AM

    Dear Cristina Sanchez,

    I: Incoming

    O: Outgoing

    Best Regards

    Jane Jing

    SAP Business One Forums team

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you for your answer, but when does the application put the value "I" or value "O"?

      I thought when I was doing the invoice(OINV) effect the value was "I", but I have seen that it's not true.

      Really, we want to distinguish into the table OBOE when an effect comes from an invoice (OINV).

      These are the data that we get from table when we run the query below. We need this query get only the first record from the table. So, we do not know which is the field that we must filter for getting the properly result for us.

      DocEntry..DocNum...CardCode..CardName................................BoeSum...............BoeType

      66.............66...........01062 - C..Pizza Zafra S.L..........................153.990000.............I

      66.............66...........00177 - A..Desarrollo Integral MTO S.R.L...2315.740000.............O

      In summary, We need to know the paid amount, paid effects included.

      Can anybody please help me?

      Thanks in advance!!!

      Best Regards,

      PD:

      SELECT OINV.DocEntry,OINV.DocNum,

      OBOE.CardCode, OBOE.CardName,

      OBOE.Boesum, OBOE.BoeType

      From OINV

      LEFT JOIN RCT2

      ON RCT2.DocEntry=OINV.DocEntry

      and InvType = 13

      LEFT JOIN ORCT

      ON (RCT2.DocNum= ORCT.DocNum)

      LEFT JOIN OBOE

      ON OBOE.PmntNum=RCT2.DocNum

      Where OINV.DocEntry = 66 AND ORCT.Canceled ='N'

      Edited by: Rui Pereira on Dec 23, 2008 4:45 PM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.