Home / SAP Business One (page 10)

SAP Business One

Licencias Perdidas

Recientemente me paso que de 26 licenicas profesionales tenia asignadas solamente 23 y no tenia disponibles, tambien me paso con las logisticas y financieras, la solucion que encontre a esto, se las comprato y es la siguiente: 1)Desconectar a atodos los usuarios del sistema 2) Detener el servicio de  Licence …

Read More »

Reconciliación Bancaria

Buenos días estimados; * Alguno de ustedes me puede decir si es posible saber si un CK esta reconciliado o no? * Y de ser posible me podrían orientar con cuales tablas debo trabajar y que tengo que tener en cuenta?

Read More »

Reducir el Log de una BD

Cuando el log de una BD crece mucho y ocupa mucho espacio hay que reducirlo, les dejo un query para hacerlo Saludos USE DEMO-MX ALTER DATABASE DEMO-MX SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (MX_Log, 1); GO -- Reset the database recovery …

Read More »

Focus five things to make a successful ERP implementation

1. Planning a project with reasonable assumptions, expectations, resources, budgets and both team roles and responsibilities will dramatically enhance success of implementation. It is important to recognize that as the company implementing new enterprise technology, you and your team are ultimately responsible for the success or failure of the project. …

Read More »

How to Manage Payroll and Expense XML File for Mexico

To comply with the new legal regulation regarding the Electronic Accounting Statements in Mexico, Journal Entry Report (JE report further) has to be submitted on monthly period effective from September 2015 including Payroll and Expense information. In order to cover this process following changes shall be done: In SAP Business …

Read More »

Inventory Transfer Request and Inventory Transfer in SAP 9.1

Dear All, Here i’m posting some knowledge which i have learnt in 9.1 version.Inventory Transfer Request and Inventory Transfer were simplified in SAP 9.1 version in Sales order and Production order modules.      1.       SALES ORDER TO INVENTORY TRANSFER REQUEST                                                 In Sales order window right click anywhere in row …

Read More »

Crystal Reports Cierra SBO

Buen día estimado; Aquí dejo este link Dropbox – Ingreso Caja Vendedor – Copy2.rpt El cual contiene  un reporte en crytal, el cual me cierra SBO 9.1 Pl-5 cuando lo ejecuto. Tengo este mismo reporte en dos formato, uno con Sub Informe y otro sin este, el que no tiene …

Read More »

Cancelamento da Invoice em moeda estrangeira

Boa Tarde a todos ! Estou com um problema no cliente e gostaria de saber se algum do grupo passou por essa experiência e poderia me ajudar. Segue abaixo a descrição do problema: – Quando efetuado  o cancelamento da Invoice Client (Nota Fiscal de Saída) pelo documento Credit Note Client …

Read More »

Produktionsauftrag schließen

Hallo möchte über die DI APi einen PA schließen, der komplett beliefert ist. Folgender Code: ProductionOrders po = oCompany.GetBusinessObject(BoObjectTypes.oProductionOrders); po.GetByKey(2); po.ProductionOrderStatus = BoProductionOrderStatusEnum.boposClosed; po.Update(); Bekomme beim Update-Befehl folgenden Fehler: Errorcode: -1116   Could not commit transaction: Error -1 detected during transaction Im SAP selber kann ich ihn schließen. PA wurde gefunden, …

Read More »

Additional Discount with formatted search

Hi all, In our days the sales guys are more and more aggressive 😈 therefore I had a challenge to create an additional discount at the line level in the sales documents. For example, we have some items with 30% discount and for certain customers the sales reps wanted to …

Read More »

CONSULTAS A UDT CON PASO DE PARAMETROS

Estimados, En SAP Business One 9.0 PL14  HANA, desde hace un tiempo que estaba buscan la forma de crear consultas en Query Manager (QM) apuntando a una tabla definida por usuario (UDT) a la cual necesariamente debía pasar parámetros utilizando las variables que el mismo QM tiene disponibles ([%0], [%1]…[%N]), …

Read More »

Outgoing queries & Sale incentive without stock transfer query

Hi All, I am venkadeswara from India – chennai State, having 1+ years of experience in SAP Business One. Here I am posting some queries reports which may helpful for newcomers. Outgoing – accounts SELECT T0.[DocNum], T0.[DocDate], T0.[DocDueDate], T0.[CardCode], T0.[CardName], T0.[Address],T1.[AcctCode], T1.[AcctName], T1.[SumApplied], T0.[Comments], T0.[JrnlMemo], T0.[CashSum], T0.[CheckSum], T0.[TrsfrSum] FROM [dbo].[OVPM]  …

Read More »

Draft Document Report (Pending for Approval)

Hi All I posted here Draft Document Report (Pending for Approval); it will helpful for new comers in SAP Business One. SELECT T0.DocEntry as ‘Draft Number’,  CASE T0.ObjType WHEN 13 THEN ‘A/R Invoice’ WHEN 14 THEN ‘A/R Credit Memo’      WHEN 15 THEN ‘Delivery’      WHEN 16 THEN ‘Return’ WHEN 17 THEN …

Read More »

Dynamic Pivot Query

Dear All, I’m Bharathiraja, having 2 years of experience in SAP B1 functional. Here i am posting some queries using dynamic pivot. 1.Total Sales Query with respective to customer and Item group. DECLARE @listCol VARCHAR(8000) DECLARE @Query VARCHAR(8000) DECLARE @OINV VARCHAR(8000) DECLARE @ORIN VARCHAR(8000) DECLARE @From varchar(15) DECLARE @To varchar(15) …

Read More »

Account Balance Query !

Hi Friends, I am posting this query for Account Balance as many of us are facing difficulty at the time of balance sheet and I guess this will help to all accountant as it will show opening Balance, GRPO value, AP value, Bank, Issue etc.. Try this.. select a.Account,a.AccountName,sum(a.OPBalance) [Opening …

Read More »